CREATE OR REPLACE PACKAGE "kesplus_base"."kesplus_pkg_menu" AUTHID CURRENT_USER AS
    /**
     * @Description 查询菜单详情
     * @param id 菜单id
     * @Return 菜单详情
     */
	FUNCTION get_by_id(id varchar) RETURN JSON;
	/**
     * @Description 修改菜单状态
     * @param id 菜单id
     * @param enabled 菜单状态值
     * @Return 菜单详情
     */
	FUNCTION change_menu_enabled(id varchar, enabled int) RETURN boolean;
	/**
     * @Description 查询当前用户菜单数据
     * @Return 菜单树形列表
     */
	FUNCTION tree_menus_by_owner() RETURN JSON;
END;

CREATE OR REPLACE PACKAGE BODY "kesplus_base"."kesplus_pkg_menu" AS WRAPPED
haw927MayoGPG1cPTPrkfq2kLP3UkcNv2W0CRErnBTmPqiKvw659ZgJybfAR
IdH2jQ5pNVV0996doxC4Ib9s9jrkyVfpxnDvwxYA9klRERNZG7GmgRDeqiHm
o8tbJk5Uexykl1TiPJsbWtsjl2Lrd1yOL66NRFgUnYV5FFjFDGHG4iZhMh2G
8BjK6w1+7hZek6k/wguz2iA3+mAccInc4Py0DkrfkTTD1iPZDR3MTLDZ5x6g
TKT1ffSffHPJCX4DZIoM3UpFwIc9DqXHX7rq1117r+e+RZCyX3VxULCQVVsi
jnmx7mOJp1j7eK9mNbNmnAxZn3STMnZOIGlxFpL/fykHMNA26XeupmKbpXJ+
o6vWtX9R+bCuTBbxCH06HlFNT4sBh9qjuZIwz/KtrrwN3+yuAZ3cGYam5F1h
QpiV1bvv0hbOvZzmagkOy102qxjFFlCC6oEWaU6TKO0cFDCw1dWD4oEVoqgb
WH0qKQYhUCHc7rzGdQ4b4+DvA7fI9HoibCQl23wWLZWZPDvHYQe8YWCsLnbE
D8r+prdc5VkfwUgYSQ4eGWMWXDxPvt5tEW8SErCDywMxOaFWKRittICZoQgI
fsL7VV8llYuWrN0BBhuix05TXnZJ/F4UrbxYvxlRZ2q3foaAGB/DJR+j4ZjM
BmmEIZgjNIwTvYg2Jssx2I45x+pshPDaTXoSFFp5owVNPwHFPTinMfuygEO9
vXRaXshP6te/xkVVpB147yqDdXCsNPN0KEXEWRg4K1s2O1J58kjH+aVOqqqB
ENmgSNnc6RserbaKJyGCCQ/ku0C/24rg/fEeaKTryiSdDZfFCebW4aZ5VrLv
uyMip9W0b/BwH2SRIrKBhAVc4RW9XLtm2/iDHmpOCFBSqIDpaN7aEmjw3XX5
rHl4auDyCmeLTyGXj9CWHYT2IPfzUI8EYbEYzezWTZBlOPx3VJENiHfAbz96
bD1V43uoOTncj/udyyAY1cfgh4aiXztxJQ5adPcWD7NDwgqRBHtFvZJGcU1V
M6hYX62fgsOgex5PMxgriVA3UK+zGxNWQRgCpTW3jOXKbbggYnvdqzrv7J6B
Jb+d8IURk6G5x8oUTS9+2Vw4NUMyGOl3ev0nGaC/M5FcX3p0iYZc6iYzo2hx
bEKcx0dEg9Rv9vlW9a4e6ZgDJ+f/4zDTSzUe5k4125zDGYROIFnbwax3xh67
cUt54HlalAwyutdIN7KqmTekSh8h+0+aHIBTK8R5JDtiQqWS7GuEac1D5h7P
PzmKQyS/V13LZylU9DfuRI5U+j6+yaN0ply8t9aWFKG8KFFj3XNZjusSvL1I
VqDNuqbPsSqa2hV5eckTTG7vjyxZj94h0AB8MLas6cN4V/WbYZgLCJbV4ZQK
icvjA5eSl8itzc7RfGqGiwQYnJUBtrKCZfQBD3vyb8TQwmAgCgeHwjfTDOpC
lCxBYQXcIdPerevKNeLdhkbP7SH22cLNFcPaQJeUhymd/xGiT/4pgPTcbu/7
pdo9mub+4kft4fMYfU2Mru/2CJjPFBqU3hbRh4GItXvgqvkRJ8UxdBuS0oeF
FiQJrqzPYb4151UlL/OnqVE80Hf/klCCQXVyRuvr2TUBTNFs7/LYPD5zzO6g
v+8CFOXPPOY0UO709Fjjxv+XcZ68juPUiQWdOiChQT5UB2rXZyadXUO5BgvO
3uUfMvb9HchCbSDlL4Uf+4tqRn5yCDROODtWi5F8kacC4WcfLViCeQk4Y2qd
FgFHWHEVgt6bo0cTnNO8I11ewAFIySIRHkIfgFIP/7zjM4IaQSKVuQTRWNo3
rccvOAtvMPuiP3m+IZMbWzHxxzkSeqDP+sge5Bc0vjUyItYvUxvrQtz7fi+X
0ZcS20hZ05U0SFSUie1KY+RSDhwmHoAvuCJMeP3GsU5uJFOt1bqjT75sXoaR
Jul5I3jGksfyxDnG0gw6uAvsnJMsoQEbSibDKw7ZesRRqDMYAI62aZ/rQLTj
s0Plr71XY+lDvQmqffatCEFRtD556ETTjksiad6sQ9Wh8azKjBSLUg/TjEdK
NKXNxzpfbncZ9HnbtGf6qISOSSlxkydiBiBIEUiAnYcBE4ipA8ReZE0Ig1+R
HEY/ex6+0lnzaSKPbI0qnHcGyAtfPO2O6oRhGPisYuXUYvwbNV4Vod4sEZTM
mXjzvJzts3sVZFPHkpl6pcjCmijjc0eLvwRDgr3bprPbpCW9vwlKDo+IEGaj
AczkNd1C0OJ1NGHm2PXoo4GAcnvHp26Mr08mGTATREPIu8ifsiWpf5ScEhZc
+9CDO04Adhat3d1EvxPaG/Kg5odwinZP3htHOHrF1X81wd11+ax5eGrg8gpn
i08hl484Lh+ljWsPOOhbweOT0Uruuz0E5o9DtQIdObztrwhnHjOLVdKWMR9T
3s5RTHQUPAOg9Sckpb7IY9Av8stZOUn1XV6JK5H4PHRoNv9ygVaW6sf4kw4g
7XeOC3DNG4bj756SxKP0WBrj6KzSTBwRsCj35IQa5CORK4Kypz8C8R7V3RWM
cIR02DOfKNKMkzGdeYHPPzmKQyS/V13LZylU9Dfu5x+wquPbKj7yCRxwKYkq
e40BrlMo31KWXJuxqvJXfORHnxnXTL4eDsNTC70zEn9nHxVyWtxfUUyFYnhZ
5/3BxyCM6TtXPwylwdiNS9U+AfSE+iZzAfHIw8mGpezboN6FZSscmGIjk4N4
fBlCW8ZMf0PhtvdFZ9MPrgwDvSqwYLk6Y2Iv+uyvvrnEI0a+1gzw5qAYTNtG
ZRcf0e3LwPm9X3wKeqs7H9w1BvTtyfO8yQS7/mAqybEOHmJZBkji6vTLdZ1T
pZQvSCe7zXFNXABVutOgggagmt7nY5jmOnPf+2OlHlV9M94Ifq06DSevGTuO
BznBb698PYqMFL9aKpbklnCu3NknBvqOOEy+JBOaCISBI79IOYkGtzgV3KIG
fir8OKqeOgs1zYyAG7ZuXnEsNIi7p6Vgax3JnclhPn1H3Ckf8y9MhfY9mq5c
ktwVizEwxldLMNTUi9UIXFBbDV44morB7NUkf1gixtw5l1BxBRAN8zfgTGXp
rUTkf7BnVkIyoFi58zYWiuyuVV3y542bnnaYPVlLsYcc6FVG1MziyYQi+Pft
fstvztUBOCM8W7Trl0QHBw9x3VOOrgAexquV5tz+S4EjAq5JjXYpHcapYCWL
ORJNNdNP/nbP3OnstTFEI+gyt90XeeAlw375W9/jwMSeAKI3xOZAPyHbUMUk
j1LVW+nj6FIDx5cd0BYTgD7wvU6pYSY8YTB5mawLtRON3M1B6eLYDTTYP28R
xIzR6j7gkFfiWvnaOADY8IZfX9XbiRvgnAMpqaje8OnNmvY8J0v5jOklDi8z
J3tsxzQhpko=
END;

